﻿CREATE TABLE [dbo].[EmployeeLicenses]
(
	[Id] int IDENTITY(1,1) NOT NULL,
	[EmployeeID] [int] NOT NULL,
	[Description] [varchar](100) NOT NULL,
	[LicenseNo] [varchar](50) NOT NULL,
	[PlaceOfIssue] [varchar](50) NULL,
	[IssueDate] [smalldatetime] NULL,
	[ExpDate] [smalldatetime] NULL,
	[NoOfYears] [varchar](15) NULL,
	[IsDriving] [bit] NULL,
	[TxnCrUser]         VARCHAR (20) NULL, 
	[TxnCrDate]         DATETIME     NULL,
	[TxnUser]           VARCHAR (20)  NULL,
	[Txndate]           DATETIME     NULL
)
go

ALTER TABLE [dbo].[EmployeeLicenses]
	ADD CONSTRAINT [PK_EmployeeLicenses]
	PRIMARY KEY ([Id])

